The result set from an Equal join includes all the records where the linked field value in both tables is an exact match. In the following example, the Customer table is linked to the Orders table by the Customer ID field. When the program finds a Customer ID in the Orders table that matches a Customer ID in the Customer table, it displays information for the corresponding records in both tables.
SQL uses the following syntax to describe an Equal join:
SELECT Customer.'Customer ID', Customer.'Customer Name', Orders.'Order Amount' FROM 'Customer' Customer, 'Orders' Orders WHERE Customer.Customer ID = Orders.Customer ID
This statement produces the following data:
Customer Table | Customer Table | Orders Table |
---|---|---|
Customer ID | Customer Name | Order Amount |
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |